<%-- 
    Document   : viewjobdetails
    Created on : Apr 12, 2012, 1:34:47 PM
    Author     : project
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<%
String src="";
if(session.getAttribute("username")!=null)
    src="../";
%>
<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn"%>
<%
    try {
        Connection con = Dbconn.getConn();
        Statement st = con.createStatement();
        String jobid = request.getParameter("jobid");
        ResultSet rs = st.executeQuery("select * from jobs,company where jobid='" + jobid + "' and jobs.compid=company.compid");
        while (rs.next()) {



%>


<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="tbl_bdr">
    <tr>
        <td align="center" valign="top"><img src="images/blank.gif" width="1" height="0" border="0" /><br />

    <tr>
        <td width="49%" height="31" align="left" valign="top" style="padding-left:3px; padding-top:3px; padding-bottom:3px;">
            <table width="99%" bgcolor="#FFFFFF" style="padding-right:0px;" class="tbl_bdr">
                <tr style="padding-top:10px;">
                    <td colspan="3" height="28"><div  class="mainheading_emp" style="float:left; text-transform:capitalize;">Job Details</div></td>
                </tr>
                <tr style="padding-top:10px;">
                    <td colspan="3"><img src="<%=src%>src/getpic.jsp?id=<%=rs.getString("compid")%>&table=company&col=logo&pk_col=compid" width="138" height="35" border="0" /></td>
                </tr>
                <tr style="padding-top:10px;">
                    <td width="18%" height="28" > <span class="tbl_pfl_txt" style="padding-left:10px;">Company Name</span></td>
                    <td width="1%" >:</td>
                    <td width="27%" ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("compname")%></span></td>
                </tr>
                <tr style="padding-top:10px;">
                    <td width="18%" height="28" > <span class="tbl_pfl_txt" style="padding-left:10px;">Job Title</span></td>
                    <td width="1%" >:</td>
                    <td width="27%" ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("jobtitle")%></span></td>
                </tr>
                <tr style="padding-top:10px;">
                    <td height="28" > <span class="tbl_pfl_txt" style="padding-left:10px;">Walkin Date</span></td>
                    <td >:</td>
                    <td ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("walkindate")%></span></td>
                </tr>
                <tr style="padding-top:10px;">
                    <td height="28"> <span class="tbl_pfl_txt" style="padding-left:10px;">Valid Until</span></td>
                    <td >:</td>
                    <td ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("validuntil")%></span></td>
                </tr>
                <tr style="padding-top:10px;">
                    <td height="28" > <span class="tbl_pfl_txt" style="padding-left:10px;">Functional Area</span></td>
                    <td >:</td>
                    <td ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("funarea")%></span></td>
                </tr>
                <%	if (rs.getFloat("minmarks10") != 0) {%>
                <tr style="padding-top:10px;">
                    <td height="28"><span class="tbl_pfl_txt" style="padding-left:10px;">Minimum 10th marks</span></td>
                    <td >:</td>
                    <td ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("minmarks10")%></span></td>
                </tr>
                <% }
       if (rs.getFloat("minmarks12") != 0) {%>
                <tr style="padding-top:10px;">
                    <td height="28" ><span class="tbl_pfl_txt" style="padding-left:10px;">Minimum 12th marks </span></td>
                    <td >:</td>
                    <td ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("minmarks12")%></span></td>
                </tr>
                <%}
    if (rs.getFloat("minmarksug") != 0) {%>
                <tr style="padding-top:10px;">
                    <td height="28"><span class="tbl_pfl_txt" style="padding-left:10px;">Minimum Bachelor degree marks</span></td>
                    <td >:</td>
                    <td ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("minmarksug")%></span></td>
                </tr>
                <%}
    if (rs.getFloat("minmarkspg") != 0) {%>
                <tr style="padding-top:10px;">
                    <td height="28"><span class="tbl_pfl_txt" style="padding-left:10px;">Minimum Post Graduate Marks</span></td>
                    <td >:</td>
                    <td ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("minmarkspg")%></span></td>
                </tr>
                <%}%>
                <tr style="padding-top:10px;">
                    <td height="28"> <span class="tbl_pfl_txt" style="padding-left:10px;">Job Role</span></td>
                    <td >:</td>
                    <td ><span style="padding-left:5px;" class="tbl_pfl_txt"><%=rs.getString("jobrole")%></span></td>
                </tr>
                <tr style="padding-top:10px;">
                    <td height="28" ><span class="tbl_pfl_txt" style="padding-left:10px;">Offered Salary</span></td>
                    <td >:</td>
                    <td ><span style="padding-left:5px;" class="tbl_pfl_txt">
                            Upto: <%=rs.getString("salary")%>&nbsp;<%=rs.getString("salarytype")%>     </span></td>
                </tr>
                <tr >
                    <td height="28" ><span class="tbl_pfl_txt" style="padding-left:10px;">Location</span></td>
                    <td >:</td>
                    <td ><span style="padding-left:5px;" class="tbl_pfl_txt">
                            <%=rs.getString("joblocation")%>    </span></td>
                </tr>
                <tr >
                    <td colspan="12" ><div style="background:#FFFFFF; width:100%" >


                            <table  width="100%" bgcolor="#FFFFFF" style="padding-right:0px;">

                                <tr>
                                    <td > <font color='#0099FF' size='+2'><strong>Job Description:</strong></font></td>
                                </tr>

                                <tr >
                                    <td style="padding-left:10px;" ><p>&nbsp;</p>
                                        <p><font  size='+1'><%=rs.getString("jobdesc")%>&nbsp;</font></p></td>
                                </tr>
                                <tr >
                                    <td></td>
                                </tr>
                                <tr>
                                    <td> <font color='#0099FF' size='+2'><strong>Desired Profile:</strong></font></td>
                                </tr>
                                <tr >
                                    <td style="padding-left:10px;" >
                                       <p>  <%=rs.getString("desiredprof")%> </p>
                                </tr>

                                <tr >
                                    <td ></td>
                                </tr>
                                <tr>
                                    <td ><font color='#0099FF' size='+2'><strong>Key Skills </strong></font></td>
                                </tr>
                                <tr >
                                    <td style="padding-left:10px;" ><p>&nbsp;</p>
                                        <p><%=rs.getString("keyskill")%>  &nbsp;</p></td>
                                </tr>
                            </table>
                        </div></td>
                </tr>
            </table>

        </td>
    </tr>



    <tr>
        <td colspan="2" align="left" valign="top"  class="tbl_bdr">
            <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" style="padding-right:0px;">
                <tr valign="middle">
                    <td height="28" colspan="3"><font color='#0099FF' size='+2'><strong>Contact Details</strong></font></div></td>
                    <td width="12%" height="28"></td>
                </tr>
                <tr>
                    <td width="17%" height="29" valign="middle"   style="padding-left:8px;"><div align="left"><strong>User Name</strong></div></td>
                    <td width="1%" valign="middle"   style="padding-left:8px;">:</td>
                    <td height="29" colspan="2" align="left" valign="middle" ><%=rs.getString("contname")%>  </td>
                </tr>
                <tr>
                    <td height="29" valign="middle" style="padding-left:8px;"><div align="left"><strong>Mobile Number </strong></div></td>
                    <td height="29" valign="middle" style="padding-left:8px;">:</td>
                    <td height="29" colspan="2" align="left" valign="middle" ><%=rs.getString("contphone")%>  </td>
                </tr>

                <tr>
                    <td height="29" valign="middle"  style="padding-left:8px;"><div align="left"><strong>Email</strong></div></td>
                    <td height="29" valign="middle"  style="padding-left:8px;">:</td>
                    <td height="29" colspan="2" align="left" valign="middle"><%=rs.getString("contemail")%>  </td>
                </tr>
            </table>

        </td>
    </tr>
    <tr>
        <td colspan="2" align="left" valign="middle" height="1px"></td>
    </tr>
    <tr>
        <td colspan="2" align="left" valign="middle" style="padding-left:3px; padding-top:3px; padding-bottom:3px;">


        </td>
    </tr>

</table>
</td>
<%}
    } catch (Exception e) {
        out.println(e);
    }
%>
